Data Summary and Table 1

SSI Sales Data

Stutti (Advisor: Dr. Seals)

2024-09-29

SSI Sales Dataset Summary

The source data contains sales transactions for a span of 48 months and comes from SSI, a Florida based B2B2C type company. The company offers custom packaging in the food industry. It offers custom branding and design as well as actual supply of the products. Customers may have transactional based sales where each order serves as it’s own agreement or customers may have a long term contract where they agree to purchase a product or several products through the course of a six month period or a year, for example. Once these agreements are established, the customer instructs it’s distributor to purchase from SSI and deliver to them. So, the purchase order, in reality comes from this distributor and not the end client.

The data available in a .csv file was read into RStudio. Below you will find the data dictionary, a Table 1 with some statistics summaries of the data and some visualizations. There are 33,818 observations and 17 variables in the data.

Data Dictionary


Attribute

Format

Description

OPCO

Varchar

The customer placing the order. In this case, typically a Distributor.

SalesOrderID

Varchar

Unique identifier assigned to each sales order.

CustomerPO

Varchar

Customer’s unique identifier of their order sent to SSI

Product

Varchar

Unique identifier assigned to each product.

Description

Varchar

Description of the product being sold.

Substrate

Varchar

Type of product/material.

RequestedDeliveryDate

Varchar

Date the delivery was scheduled originally.

DateFulfilled

Varchar

Date the delivery was made.

qtyOrdered

Numeric

Quantity ordered on the order.

qtyFulfilled

Numeric

Quantity delivered on the order.

UnitPrice

Numeric

Price of each case of product SSI charges the customer.

TotalPrice

Numeric

Total price of the sales order.

Class

Varchar

Customer name

ShipToName

Varchar

Address name of ordering party

ShipToAddress

Varchar

Address where order needs to be delivered

SalesOrderStatus

Varchar

Status of Sales order

SalesItemStatus

Varchar

Status of each line item on the sales order

Table 1 - SSI Sales Data

Total Orders Closed Short Fulfilled
(n=7585) (n=733) (n=6852)
Top Customers
Smoothie Island 1701 (22.43%) 455 (62.07%) 1246 (18.18%)
Philly Bite 1556 (20.51%) 267 (36.43%) 1289 (18.81%)
PlatePioneers 1396 (18.40%) 143 (19.51%) 1253 (18.29%)
Berl Company 906 (11.94%) 5 (0.68%) 901 (13.15%)
DineLink Intl 589 (7.77%) 42 (5.73%) 547 (7.98%)
Top Products
DC-01 1135 (14.96%) 345 (47.07%) 790 (11.53%)
TSC-PQB-01 1087 (14.33%) 389 (53.07%) 698 (10.19%)
TSC-PW14X16-01 848 (11.18%) 283 (38.61%) 565 (8.25%)
CMI-PCK-01 802 (10.57%) 288 (39.29%) 514 (7.50%)
PC-05-B1 745 (9.82%) 220 (30.01%) 525 (7.66%)
Top Distributors
Ed Don & Company - Miramar 210 (2.77%) 0 (0.00%) 210 (3.06%)
PFG- Gainesville 197 (2.60%) 0 (0.00%) 197 (2.88%)
Ed Don & Company -Woodridge 186 (2.45%) 0 (0.00%) 186 (2.71%)
Ed Don & Company - MiraLoma 180 (2.37%) 0 (0.00%) 180 (2.63%)
.Ed Don - Miramar 162 (2.14%) 0 (0.00%) 162 (2.36%)
Top Substrates Paper Plastic Bagasse
Revenue($103,826,286) $54,838,585 (52.82%) $40,336,669 (38.85%) $4,350,337 (4.19%)
Quantity Ordered Min Mean Max
Total Ordered(1,971,237) 1 61.47 23,160
Unit Price Min Mean Max
Key Stats $0.16 $62.60 $864.00
Total Price Min Mean Max
Key Stats $4.92 $3,430.74 $143,084.74

Data Visualization1

Data Visualization2

Data Visualization3

Data Visualization4

Data Visualization5

Data Visualization6